if object_id('BIMonitor.SSISProblemSummary') is not null
  drop table BIMonitor.SSISProblemSummary
go

create table BIMonitor.SSISProblemSummary
 (Environment                   varchar(75) not null,
  ProblemType                   varchar(10) not null,
  SSRSProblemTypeSort           smallint not null,
  LT1Count                      int default 0 not null,
  [1_2Count]                    int default 0 not null,
  [3_6Count]                    int default 0 not null,
  [7_12Count]                   int default 0 not null,
  [13_24Count]                  int default 0 not null,
  CheckDate                     datetime default getdate() not null,

  constraint pk_SSISProblemSummary primary key(Environment,ProblemType));